﻿CREATE TYPE [flcr].[DEVICE_CONFIG_UDT] AS  TABLE (
    [DEVICE_CONFIG_ID]          INT           NULL,
    [AUDIT_USER]                VARCHAR (100) NULL,
    [AUDIT_DTTM]                DATETIME      NULL,
    [AUDIT_DTTM_TZ]             INT           NULL,
    [AUDIT_MOD_USER]            VARCHAR (100) NULL,
    [AUDIT_MOD_DTTM]            DATETIME      NULL,
    [AUDIT_MOD_DTTM_TZ]         INT           NULL,
    [BUILTIN]                   BIT           NULL,
    [WRKFL_ITEM_ID]             INT           NULL,
    [WRKFL_STATUS_ID]           INT           NULL,
    [ACTIVE_FLG]                BIT           NULL,
    [SORT_ORDER]                INT           NULL,
    [DEVICE_ID]                 INT           NULL,
    [DEVICE_CONFIG_PROPERTY_ID] INT           NULL,
    [DEVICE_CONFIG_PROP_VALUE]  VARCHAR (MAX) NULL,
    [UTIL_MEASURES_TYPE]        INT           NULL,
    [PARENT_ID]                 INT           NULL,
    [AUTOCOLLECT_FLG]           BIT           NULL,
    [AUTOCOLLECT_MODULE_ID]     INT           NULL,
    [AUTOCOLLECT_FDTTM]         DATETIME      NULL,
    [AUTOCOLLECT_FDTTM_TZ]      INT           NULL,
    [AUTOCOLLECT_LDTTM]         DATETIME      NULL,
    [AUTOCOLLECT_LDTTM_TZ]      INT           NULL,
    [AUTOCOLLECT_AUDIT_USER]    VARCHAR (100) NULL);

